package com.sp2.dev.test.hoteljxl;

/**
 * Created by IntelliJ IDEA.
 * User: zhimingli
 * Date: 14-2-7
 * Time: 下午5:05
 * To change this template use File | Settings | File Templates.
 */
public class CsvSql {
    /**
     CREATE TABLE `hotel` (
     `CName` varchar(100) DEFAULT NULL,
     `CardNo` varchar(100) DEFAULT NULL,
     `Descriot` varchar(100) DEFAULT NULL,
     `CtfTp` varchar(100) DEFAULT NULL,
     `CtfId` varchar(100) DEFAULT NULL,
     `Gender` varchar(50) DEFAULT NULL,
     `Birthday` varchar(100) DEFAULT NULL,
     `Address` varchar(500) DEFAULT NULL,
     `Zip` varchar(200) DEFAULT NULL,
     `Dirty` varchar(200) DEFAULT NULL,
     `District1` varchar(200) DEFAULT NULL,
     `District2` varchar(200) DEFAULT NULL,
     `District3` varchar(200) DEFAULT NULL,
     `District4` varchar(200) DEFAULT NULL,
     `District5` varchar(200) DEFAULT NULL,
     `District6` varchar(200) DEFAULT NULL,
     `FirstNm` varchar(200) DEFAULT NULL,
     `LastNm` varchar(200) DEFAULT NULL,
     `Duty` varchar(200) DEFAULT NULL,
     `Mobile` varchar(200) DEFAULT NULL,
     `Tel` varchar(200) DEFAULT NULL,
     `Fax` varchar(200) DEFAULT NULL,
     `EMail` varchar(200) DEFAULT NULL,
     `Nation` varchar(200) DEFAULT NULL,
     `Taste` varchar(200) DEFAULT NULL,
     `Education` varchar(200) DEFAULT NULL,
     `Company` varchar(200) DEFAULT NULL,
     `CTel` varchar(200) DEFAULT NULL,
     `CAddress` varchar(200) DEFAULT NULL,
     `CZip` varchar(200) DEFAULT NULL,
     `Family` varchar(200) DEFAULT NULL,
     `CVersion` varchar(200) DEFAULT NULL,
     `id` varchar(200) DEFAULT NULL
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8

     */
/**
 SELECT * FROM hotel WHERE address LIKE  '%会昌县%'
 UNION ALL
 SELECT * FROM hotel1 WHERE address LIKE  '%会昌县%'
 UNION ALL
 SELECT * FROM hotel2 WHERE  address LIKE  '%会昌县%'
 UNION ALL
 SELECT * FROM hotel3 WHERE  address LIKE  '%会昌县%'
 UNION ALL
 SELECT * FROM hotel4 WHERE  address LIKE  '%会昌县%'
 UNION ALL
 SELECT * FROM hotel5 WHERE  address LIKE  '%会昌县%'
 UNION ALL
 SELECT * FROM hotel6 WHERE  address LIKE  '%会昌县%'
 UNION ALL
 SELECT * FROM hotel7 WHERE  address LIKE  '%会昌县%'
 UNION ALL
 SELECT * FROM hotel8 WHERE  address LIKE  '%会昌县%'
 UNION ALL
 SELECT * FROM hotel9 WHERE  address LIKE  '%会昌县%'
 ORDER BY 5 DESC
 */
}
